DROP TABLE IF EXISTS jms_ods.yl_lmdm_sys_user_role;
CREATE EXTERNAL TABLE jms_ods.yl_lmdm_sys_user_role(
ID               bigint          comment          '关联id'   ,        --NUMBER(11)
USER_ID               bigint          comment          '用户id'   ,        --NUMBER(11)
ROLE_ID               bigint          comment          '角色id'           --NUMBER(11)
 )
 COMMENT '用户-角色-关联表'
 PARTITIONED BY (dt STRING COMMENT '更新/创建日期 (yyyy-MM-dd)')
 STORED AS PARQUET
 LOCATION '/dw/hive/jms_ods.db/external/yl_lmdm_sys_user_role'
 TBLPROPERTIES (
 'discover.partitions'='false',
 'parquet.column.index.access'='true'
 );

MSCK REPAIR TABLE jms_ods.yl_lmdm_sys_user_role;
